package com.framework.Module.jxc.jxcgoods;

import com.framework.Table.Table;
import com.framerock.baselib.Rock;


public class Tablejxcgoods extends Table {


    protected void initTable() {
        this.tablename   = "jxcgoods";
        this.tablenamesm = "出入库详情";

        this.flowsetMap  = Rock.getMap(new String[]{
                "type", "进销存",
                "sort", "55",
                "isxt", "2",
                "summary", "[{dt}]{sname}:{count}{sunit}",
                "imgurl","https://xinhu-1251238447.file.myqcloud.com/img/13994.png",
                "istj","1"
        });
        this.addfields("dt", "date", null, "日期", new String[]{
                "isbt","1",
                "devval","{date}"
        });
        this.addfields("type", "tinyint(1)", "0", "类型@0|入库,1|出库", new String[]{
                "isbt","1",
                "islu","0",
                "fieldstype","select"
        });
        this.addfields("kind", "tinyint(2)", "0", "出入库类型@jxccrku:kinddata", new String[]{
                "isbt","1",
                "isss","1",
                "fieldstype","select"
        });
        this.addfields("ckid", "int(11)", "0", "对应仓库@jxccrku:ckiddata", new String[]{
                "fieldstype","select"
        });

        this.addfields("sname", "varchar(200)", "", "商品@jxcgoodn:spdata,sid", new String[]{
                "isbt","1",
                "fieldstype","selectdatafalse",
                "isss","1",
                "isalign","1"
        });
        this.addfields("sid", "int(11)", "0", "对应商品", new String[]{
                "notelement","1"
        });
        this.addfields("count", "decimal(10,2)", "0.00", "数量", new String[]{
                "islb","1",
                "isalign","2"
        });
        this.addfields("sunit", "varchar(20)", "", "单位", new String[]{
                "islb","1"
        });
        this.addfields("price", "decimal(10,2)", "0.00", "单价", new String[]{
                "isalign","2"
        });
        this.addfields("custname", "varchar(100)", "", "相关客户@custdata,custid", new String[]{
                "isbt","0",
                "isss","1",
                "fieldstype","selectdatafalse"
        });
        this.addfields("custid", "int(11)", "0", "客户ID", new String[]{
                "islu","0",
                "islb","0",
        });
        this.addfields("cid", "int(11)", "0", "对应单位", new String[]{
                "islu","0",
                "notelement","1"
        });
        this.addfields("explain", "varchar(500)", "", "说明", new String[]{
                "isalign","1",
                "islb","0",
                "fieldstype","textarea"
        });
        this.addfields("aid", "int(11)", "0", "操作人ID", new String[]{
                "islu","0",
                "islb","0",
                "notelement","1"
        });
        this.addfields("optname", "varchar(50)", "", "操作人", new String[]{
                "islu","0",
        });
        this.addfields("optdt", "datetime", null, "操作时间", new String[]{
                "islu","0",
        });
        this.addfields("sfile", "varchar(100)", "", "相关文件", new String[]{
                "islb","0",
                "fieldstype","uploadfile"
        });
        this.addfields("mid", "int(11)", "0", "主ID@@关联主jxcgoodm.id", new String[]{
                "fieldstype","hidden",
                "islb","0",
                "iszs","0",
                "notelement","1"
        });

        this.addfields("cid", "KEY", "`cid`", "单位ID");

    }

}
